﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="RssFeedScenes.aspx.vb" Inherits="helzwebscripting.RssFeedScenes" ContentType="text/xml" %>
<%@ Import Namespace="System.Data" %>

<asp:Repeater id="RepeaterRSS" runat="server" 
    DataSourceID="RSSQuotesDataSource">
<HeaderTemplate>
<rss version="2.0">
  <channel>
    <title>Twilighters Community</title>
    <description>Here is the Twilighters Community Quotes Feed</description>   
</HeaderTemplate>

<ItemTemplate>
  <item>

    <title><%# RemoveIllegalCharacters(DataBinder.Eval(Container.DataItem, "Quote"))%></title>

    <link><%# okURL("QuoteDiscuss.aspx?ID=")%><%# RemoveIllegalCharacters(DataBinder.Eval(Container.DataItem, "ID"))%></link>

    <description>Quote added by <%# RemoveIllegalCharacters(DataBinder.Eval(Container.DataItem, "TwiWriter"))%></description>
   <br />
  </item>

</ItemTemplate>

<FooterTemplate>
  </channel>
</rss>   
</FooterTemplate>
</asp:Repeater>

<asp:SqlDataSource ID="RSSQuotesDataSource" runat="server" 
    ConnectionString="<%$ ConnectionStrings:TwilightConn %>" 
    ProviderName="<%$ ConnectionStrings:TwilightConn.ProviderName %>" 
    SelectCommand="SELECT [ID], [Quote], [TwiWriter] FROM [Quotes] ORDER BY [ID] DESC">
</asp:SqlDataSource>
